{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='现代')]\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口现代>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='现代']\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LBE')|(all1['3']=='LNB')]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['北京现代>>', '进口现代>>', '北京现代新能源>>', '四川现代>>', '北京现代', '现代', '四川现代'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BH7165RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1560</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1591</td>\n",
       "      <td>132.4</td>\n",
       "      <td>LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BH7202RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1495</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1999</td>\n",
       "      <td>118</td>\n",
       "      <td>LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BH7205RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1610</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1998</td>\n",
       "      <td>177</td>\n",
       "      <td>LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BH7164RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1530</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1591</td>\n",
       "      <td>132.4</td>\n",
       "      <td>LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BH7165RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1560</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1591</td>\n",
       "      <td>132.4</td>\n",
       "      <td>LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BH7202RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1495</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1999</td>\n",
       "      <td>118</td>\n",
       "      <td>LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BH7164RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1530</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1591</td>\n",
       "      <td>132.4</td>\n",
       "      <td>LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BH7205RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1610</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1998</td>\n",
       "      <td>177</td>\n",
       "      <td>LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BH7164RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1530</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1591</td>\n",
       "      <td>132.4</td>\n",
       "      <td>LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BH7165RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1560</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1591</td>\n",
       "      <td>132.4</td>\n",
       "      <td>LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>BH7202RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1495</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1999</td>\n",
       "      <td>118</td>\n",
       "      <td>LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BH7205RAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1610</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855</td>\n",
       "      <td>1835</td>\n",
       "      <td>1485</td>\n",
       "      <td>1998</td>\n",
       "      <td>177</td>\n",
       "      <td>LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2805</td>\n",
       "      <td>4855x1835x1485</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BH7160VAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1167,1190</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510</td>\n",
       "      <td>1765</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LBE2DAFB×××××××××,LBE2DAFC×××××××××,LBE2DAFD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510x1765x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BH7161VAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1190</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510</td>\n",
       "      <td>1765</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LBE2DAFB×××××××××,LBE2DAFC×××××××××,LBE2DAFD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510x1765x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BH7160VMV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1120,1150</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510</td>\n",
       "      <td>1765</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LBE2DAEB×××××××××,LBE2DAEC×××××××××,LBE2DAED××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510x1765x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BH7161VMV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1150</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510</td>\n",
       "      <td>1765</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LBE2DAEB×××××××××,LBE2DAEC×××××××××,LBE2DAED××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510x1765x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BH7160VAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1167,1190</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510</td>\n",
       "      <td>1765</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LBE2DAFB×××××××××,LBE2DAFC×××××××××,LBE2DAFD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510x1765x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BH7161VMV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1150</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510</td>\n",
       "      <td>1765</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LBE2DAEB×××××××××,LBE2DAEC×××××××××,LBE2DAED××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510x1765x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BH7161VAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1190</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510</td>\n",
       "      <td>1765</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LBE2DAFB×××××××××,LBE2DAFC×××××××××,LBE2DAFD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510x1765x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BH7160VMV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1120,1150</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510</td>\n",
       "      <td>1765</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>90.2</td>\n",
       "      <td>LBE2DAEB×××××××××,LBE2DAEC×××××××××,LBE2DAED××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4510x1765x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BH7162PAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1479</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>128.7</td>\n",
       "      <td>LBECFAFC×××××××××,LBECFAFD×××××××××,LBECFAFB××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BH7163PAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1481</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>128.7</td>\n",
       "      <td>LBECFAFC×××××××××,LBECFAFD×××××××××,LBECFAFB××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BH7186PAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1435</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LBECFAHB×××××××××,LBECFAHC×××××××××,LBECFAHD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>BH7185PAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1431</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LBECFAHB×××××××××,LBECFAHC×××××××××,LBECFAHD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BH7185PMV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1367</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LBECFAGB×××××××××,LBECFAGC×××××××××,LBECFAGD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BH7163PAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1481</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>128.7</td>\n",
       "      <td>LBECFAFC×××××××××,LBECFAFD×××××××××,LBECFAFB××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BH7186PAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1435</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LBECFAHB×××××××××,LBECFAHC×××××××××,LBECFAHD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BH7162PAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1479</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1591</td>\n",
       "      <td>128.7</td>\n",
       "      <td>LBECFAFC×××××××××,LBECFAFD×××××××××,LBECFAFB××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BH7185PMV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1367</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LBECFAGB×××××××××,LBECFAGC×××××××××,LBECFAGD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>BH7185PAV</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1431</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710</td>\n",
       "      <td>1820</td>\n",
       "      <td>1470</td>\n",
       "      <td>1797</td>\n",
       "      <td>105</td>\n",
       "      <td>LBECFAHB×××××××××,LBECFAHC×××××××××,LBECFAHD××...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2770</td>\n",
       "      <td>4710x1820x1470</td>\n",
       "      <td>现代</td>\n",
       "      <td>名图</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>BH7164AY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1254</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542</td>\n",
       "      <td>1775</td>\n",
       "      <td>1490</td>\n",
       "      <td>1599</td>\n",
       "      <td>82</td>\n",
       "      <td>LBEHDAFB×××××××××</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542x1775x1490</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>BH7182MX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1265</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542</td>\n",
       "      <td>1775</td>\n",
       "      <td>1490</td>\n",
       "      <td>1795</td>\n",
       "      <td>96</td>\n",
       "      <td>LBEHDAGB×××××××××</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542x1775x1490</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>BH7164AX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1254</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542</td>\n",
       "      <td>1775</td>\n",
       "      <td>1490</td>\n",
       "      <td>1599</td>\n",
       "      <td>82</td>\n",
       "      <td>LBEHDAFB×××××××××</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542x1775x1490</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>BH7164MX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1236</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542</td>\n",
       "      <td>1775</td>\n",
       "      <td>1490</td>\n",
       "      <td>1599</td>\n",
       "      <td>82</td>\n",
       "      <td>LBEHDAEB×××××××××</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542x1775x1490</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>BH7182AX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1279</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542</td>\n",
       "      <td>1775</td>\n",
       "      <td>1490</td>\n",
       "      <td>1795</td>\n",
       "      <td>96</td>\n",
       "      <td>LBEHDAHB×××××××××</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542x1775x1490</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>BH7182AY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1279</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542</td>\n",
       "      <td>1775</td>\n",
       "      <td>1490</td>\n",
       "      <td>1795</td>\n",
       "      <td>96</td>\n",
       "      <td>LBEHDAHB×××××××××</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2650</td>\n",
       "      <td>4542x1775x1490</td>\n",
       "      <td>现代</td>\n",
       "      <td>悦动</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>BH7240AX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1550</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>2359</td>\n",
       "      <td>121.4</td>\n",
       "      <td>LBENFANB×××××××××\\rLBENFANC×××××××××\\rLBENFAND...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>BH7240AY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1535</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>2359</td>\n",
       "      <td>121.4</td>\n",
       "      <td>LBENFANB×××××××××\\rLBENFANC×××××××××\\rLBENFAND...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>BH7202AY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1510</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAKB×××××××××\\rLBENFAKC×××××××××\\rLBENFAKD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>BH7202MY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1470</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAJB×××××××××\\rLBENFAJC×××××××××\\rLBENFAJD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>BH7202MX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1478</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAJB×××××××××\\rLBENFAJC×××××××××\\rLBENFAJD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>BH7202AX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1510</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAKB×××××××××\\rLBENFAKC×××××××××\\rLBENFAKD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>BH7202AY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1510</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAKB×××××××××\\rLBENFAKC×××××××××\\rLBENFAKD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>BH7202MY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1470</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAJB×××××××××\\rLBENFAJC×××××××××\\rLBENFAJD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>BH7240AY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1535</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>2359</td>\n",
       "      <td>121.4</td>\n",
       "      <td>LBENFANB×××××××××\\rLBENFANC×××××××××\\rLBENFAND...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>BH7202MX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1478</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAJB×××××××××\\rLBENFAJC×××××××××\\rLBENFAJD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>BH7202AX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1510</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAKB×××××××××\\rLBENFAKC×××××××××\\rLBENFAKD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>BH7240MX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1541</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>2359</td>\n",
       "      <td>121.4</td>\n",
       "      <td>LBENFAMB×××××××××\\rLBENFAMC×××××××××\\rLBENFAMD...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>BH7240AX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1550</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>2359</td>\n",
       "      <td>121.4</td>\n",
       "      <td>LBENFANB×××××××××\\rLBENFANC×××××××××\\rLBENFAND...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>BH7202AW</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1500</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAKB×××××××××\\r,LBENFAKC×××××××××\\r,LBENFA...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>BH7202MW</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1478</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>1998</td>\n",
       "      <td>107.4</td>\n",
       "      <td>LBENFAJB×××××××××\\r,LBENFAJC×××××××××\\r,LBENFA...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>BH7240AW</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1550</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>2359</td>\n",
       "      <td>121.4</td>\n",
       "      <td>LBENFANB×××××××××\\r,LBENFANC×××××××××\\r,LBENFA...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>BH7240MW</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1541</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>2359</td>\n",
       "      <td>121.4</td>\n",
       "      <td>LBENFAMB×××××××××\\r,LBENFAMC×××××××××\\r,LBENFA...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>BH7330AW</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1661</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800</td>\n",
       "      <td>1832</td>\n",
       "      <td>1475</td>\n",
       "      <td>3343</td>\n",
       "      <td>173</td>\n",
       "      <td>LBENFATB×××××××××\\r,LBENFATC×××××××××\\r,LBENFA...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2730</td>\n",
       "      <td>4800x1832x1475</td>\n",
       "      <td>现代</td>\n",
       "      <td>御翔</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>BH7200AY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1485,1445</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LBEEFAKA×××××××××\\rLBEEFAKB×××××××××\\rLBEEFAKF...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747x1820x1420</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>BH7200MY</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1460,1420</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LBEEFAJA×××××××××\\rLBEEFAJB×××××××××\\rLBEEFAJF...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747x1820x1420</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>BH7200MX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1435,1470</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LBEEFAJA×××××××××\\rLBEEFAJB×××××××××\\rLBEEFAJC...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747x1820x1420</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>BH7200AX</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1445,1480</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747</td>\n",
       "      <td>1820</td>\n",
       "      <td>1420</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LBEEFAKA×××××××××\\rLBEEFAKB×××××××××\\rLBEEFAKC...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LBE</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747x1820x1420</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>BH7200A</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1445</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747</td>\n",
       "      <td>1820</td>\n",
       "      <td>1440</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LNBSCCBK×××××××××\\r,LNBSCCBE×××××××××\\r,LBESCC...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747x1820x1440</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>BH7200M</td>\n",
       "      <td>北京现代</td>\n",
       "      <td>1435</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747</td>\n",
       "      <td>1820</td>\n",
       "      <td>1440</td>\n",
       "      <td>1975</td>\n",
       "      <td>101</td>\n",
       "      <td>LNBSCCBC×××××××××\\r,LNBSCCBH×××××××××\\r,LBESCC...</td>\n",
       "      <td>北京现代汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2700</td>\n",
       "      <td>4747x1820x1440</td>\n",
       "      <td>现代</td>\n",
       "      <td>索纳塔</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>393 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    notice_type brand_x curb_weight Wheelbase car_length car_width car_height  \\\n",
       "0     BH7165RAV    北京现代        1560      2805       4855      1835       1485   \n",
       "1     BH7202RAV    北京现代        1495      2805       4855      1835       1485   \n",
       "2     BH7205RAV    北京现代        1610      2805       4855      1835       1485   \n",
       "3     BH7164RAV    北京现代        1530      2805       4855      1835       1485   \n",
       "4     BH7165RAV    北京现代        1560      2805       4855      1835       1485   \n",
       "5     BH7202RAV    北京现代        1495      2805       4855      1835       1485   \n",
       "6     BH7164RAV    北京现代        1530      2805       4855      1835       1485   \n",
       "7     BH7205RAV    北京现代        1610      2805       4855      1835       1485   \n",
       "8     BH7164RAV    北京现代        1530      2805       4855      1835       1485   \n",
       "9     BH7165RAV    北京现代        1560      2805       4855      1835       1485   \n",
       "10    BH7202RAV    北京现代        1495      2805       4855      1835       1485   \n",
       "11    BH7205RAV    北京现代        1610      2805       4855      1835       1485   \n",
       "12    BH7160VAV    北京现代   1167,1190      2650       4510      1765       1470   \n",
       "13    BH7161VAV    北京现代        1190      2650       4510      1765       1470   \n",
       "14    BH7160VMV    北京现代   1120,1150      2650       4510      1765       1470   \n",
       "15    BH7161VMV    北京现代        1150      2650       4510      1765       1470   \n",
       "16    BH7160VAV    北京现代   1167,1190      2650       4510      1765       1470   \n",
       "17    BH7161VMV    北京现代        1150      2650       4510      1765       1470   \n",
       "18    BH7161VAV    北京现代        1190      2650       4510      1765       1470   \n",
       "19    BH7160VMV    北京现代   1120,1150      2650       4510      1765       1470   \n",
       "20    BH7162PAV    北京现代        1479      2770       4710      1820       1470   \n",
       "21    BH7163PAV    北京现代        1481      2770       4710      1820       1470   \n",
       "22    BH7186PAV    北京现代        1435      2770       4710      1820       1470   \n",
       "23    BH7185PAV    北京现代        1431      2770       4710      1820       1470   \n",
       "24    BH7185PMV    北京现代        1367      2770       4710      1820       1470   \n",
       "25    BH7163PAV    北京现代        1481      2770       4710      1820       1470   \n",
       "26    BH7186PAV    北京现代        1435      2770       4710      1820       1470   \n",
       "27    BH7162PAV    北京现代        1479      2770       4710      1820       1470   \n",
       "28    BH7185PMV    北京现代        1367      2770       4710      1820       1470   \n",
       "29    BH7185PAV    北京现代        1431      2770       4710      1820       1470   \n",
       "..          ...     ...         ...       ...        ...       ...        ...   \n",
       "363    BH7164AY    北京现代        1254      2650       4542      1775       1490   \n",
       "364    BH7182MX    北京现代        1265      2650       4542      1775       1490   \n",
       "365    BH7164AX    北京现代        1254      2650       4542      1775       1490   \n",
       "366    BH7164MX    北京现代        1236      2650       4542      1775       1490   \n",
       "367    BH7182AX    北京现代        1279      2650       4542      1775       1490   \n",
       "368    BH7182AY    北京现代        1279      2650       4542      1775       1490   \n",
       "369    BH7240AX    北京现代        1550      2730       4800      1832       1475   \n",
       "370    BH7240AY    北京现代        1535      2730       4800      1832       1475   \n",
       "371    BH7202AY    北京现代        1510      2730       4800      1832       1475   \n",
       "372    BH7202MY    北京现代        1470      2730       4800      1832       1475   \n",
       "373    BH7202MX    北京现代        1478      2730       4800      1832       1475   \n",
       "374    BH7202AX    北京现代        1510      2730       4800      1832       1475   \n",
       "375    BH7202AY    北京现代        1510      2730       4800      1832       1475   \n",
       "376    BH7202MY    北京现代        1470      2730       4800      1832       1475   \n",
       "377    BH7240AY    北京现代        1535      2730       4800      1832       1475   \n",
       "378    BH7202MX    北京现代        1478      2730       4800      1832       1475   \n",
       "379    BH7202AX    北京现代        1510      2730       4800      1832       1475   \n",
       "380    BH7240MX    北京现代        1541      2730       4800      1832       1475   \n",
       "381    BH7240AX    北京现代        1550      2730       4800      1832       1475   \n",
       "382    BH7202AW    北京现代        1500      2730       4800      1832       1475   \n",
       "383    BH7202MW    北京现代        1478      2730       4800      1832       1475   \n",
       "384    BH7240AW    北京现代        1550      2730       4800      1832       1475   \n",
       "385    BH7240MW    北京现代        1541      2730       4800      1832       1475   \n",
       "386    BH7330AW    北京现代        1661      2730       4800      1832       1475   \n",
       "387    BH7200AY    北京现代   1485,1445      2700       4747      1820       1420   \n",
       "388    BH7200MY    北京现代   1460,1420      2700       4747      1820       1420   \n",
       "389    BH7200MX    北京现代   1435,1470      2700       4747      1820       1420   \n",
       "390    BH7200AX    北京现代   1445,1480      2700       4747      1820       1420   \n",
       "391     BH7200A    北京现代        1445      2700       4747      1820       1440   \n",
       "392     BH7200M    北京现代        1435      2700       4747      1820       1440   \n",
       "\n",
       "    Displacement  power                                                vin  \\\n",
       "0           1591  132.4  LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...   \n",
       "1           1999    118  LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...   \n",
       "2           1998    177  LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...   \n",
       "3           1591  132.4  LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...   \n",
       "4           1591  132.4  LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...   \n",
       "5           1999    118  LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...   \n",
       "6           1591  132.4  LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...   \n",
       "7           1998    177  LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...   \n",
       "8           1591  132.4  LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...   \n",
       "9           1591  132.4  LBELFAFC×××××××××,LBELFAFD×××××××××,LBELFAFE××...   \n",
       "10          1999    118  LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...   \n",
       "11          1998    177  LBELFAKC×××××××××,LBELFAKD×××××××××,LBELFAKE××...   \n",
       "12          1591   90.2  LBE2DAFB×××××××××,LBE2DAFC×××××××××,LBE2DAFD××...   \n",
       "13          1591   90.2  LBE2DAFB×××××××××,LBE2DAFC×××××××××,LBE2DAFD××...   \n",
       "14          1591   90.2  LBE2DAEB×××××××××,LBE2DAEC×××××××××,LBE2DAED××...   \n",
       "15          1591   90.2  LBE2DAEB×××××××××,LBE2DAEC×××××××××,LBE2DAED××...   \n",
       "16          1591   90.2  LBE2DAFB×××××××××,LBE2DAFC×××××××××,LBE2DAFD××...   \n",
       "17          1591   90.2  LBE2DAEB×××××××××,LBE2DAEC×××××××××,LBE2DAED××...   \n",
       "18          1591   90.2  LBE2DAFB×××××××××,LBE2DAFC×××××××××,LBE2DAFD××...   \n",
       "19          1591   90.2  LBE2DAEB×××××××××,LBE2DAEC×××××××××,LBE2DAED××...   \n",
       "20          1591  128.7  LBECFAFC×××××××××,LBECFAFD×××××××××,LBECFAFB××...   \n",
       "21          1591  128.7  LBECFAFC×××××××××,LBECFAFD×××××××××,LBECFAFB××...   \n",
       "22          1797    105  LBECFAHB×××××××××,LBECFAHC×××××××××,LBECFAHD××...   \n",
       "23          1797    105  LBECFAHB×××××××××,LBECFAHC×××××××××,LBECFAHD××...   \n",
       "24          1797    105  LBECFAGB×××××××××,LBECFAGC×××××××××,LBECFAGD××...   \n",
       "25          1591  128.7  LBECFAFC×××××××××,LBECFAFD×××××××××,LBECFAFB××...   \n",
       "26          1797    105  LBECFAHB×××××××××,LBECFAHC×××××××××,LBECFAHD××...   \n",
       "27          1591  128.7  LBECFAFC×××××××××,LBECFAFD×××××××××,LBECFAFB××...   \n",
       "28          1797    105  LBECFAGB×××××××××,LBECFAGC×××××××××,LBECFAGD××...   \n",
       "29          1797    105  LBECFAHB×××××××××,LBECFAHC×××××××××,LBECFAHD××...   \n",
       "..           ...    ...                                                ...   \n",
       "363         1599     82                                  LBEHDAFB×××××××××   \n",
       "364         1795     96                                  LBEHDAGB×××××××××   \n",
       "365         1599     82                                  LBEHDAFB×××××××××   \n",
       "366         1599     82                                  LBEHDAEB×××××××××   \n",
       "367         1795     96                                  LBEHDAHB×××××××××   \n",
       "368         1795     96                                  LBEHDAHB×××××××××   \n",
       "369         2359  121.4  LBENFANB×××××××××\\rLBENFANC×××××××××\\rLBENFAND...   \n",
       "370         2359  121.4  LBENFANB×××××××××\\rLBENFANC×××××××××\\rLBENFAND...   \n",
       "371         1998  107.4  LBENFAKB×××××××××\\rLBENFAKC×××××××××\\rLBENFAKD...   \n",
       "372         1998  107.4  LBENFAJB×××××××××\\rLBENFAJC×××××××××\\rLBENFAJD...   \n",
       "373         1998  107.4  LBENFAJB×××××××××\\rLBENFAJC×××××××××\\rLBENFAJD...   \n",
       "374         1998  107.4  LBENFAKB×××××××××\\rLBENFAKC×××××××××\\rLBENFAKD...   \n",
       "375         1998  107.4  LBENFAKB×××××××××\\rLBENFAKC×××××××××\\rLBENFAKD...   \n",
       "376         1998  107.4  LBENFAJB×××××××××\\rLBENFAJC×××××××××\\rLBENFAJD...   \n",
       "377         2359  121.4  LBENFANB×××××××××\\rLBENFANC×××××××××\\rLBENFAND...   \n",
       "378         1998  107.4  LBENFAJB×××××××××\\rLBENFAJC×××××××××\\rLBENFAJD...   \n",
       "379         1998  107.4  LBENFAKB×××××××××\\rLBENFAKC×××××××××\\rLBENFAKD...   \n",
       "380         2359  121.4  LBENFAMB×××××××××\\rLBENFAMC×××××××××\\rLBENFAMD...   \n",
       "381         2359  121.4  LBENFANB×××××××××\\rLBENFANC×××××××××\\rLBENFAND...   \n",
       "382         1998  107.4  LBENFAKB×××××××××\\r,LBENFAKC×××××××××\\r,LBENFA...   \n",
       "383         1998  107.4  LBENFAJB×××××××××\\r,LBENFAJC×××××××××\\r,LBENFA...   \n",
       "384         2359  121.4  LBENFANB×××××××××\\r,LBENFANC×××××××××\\r,LBENFA...   \n",
       "385         2359  121.4  LBENFAMB×××××××××\\r,LBENFAMC×××××××××\\r,LBENFA...   \n",
       "386         3343    173  LBENFATB×××××××××\\r,LBENFATC×××××××××\\r,LBENFA...   \n",
       "387         1975    101  LBEEFAKA×××××××××\\rLBEEFAKB×××××××××\\rLBEEFAKF...   \n",
       "388         1975    101  LBEEFAJA×××××××××\\rLBEEFAJB×××××××××\\rLBEEFAJF...   \n",
       "389         1975    101  LBEEFAJA×××××××××\\rLBEEFAJB×××××××××\\rLBEEFAJC...   \n",
       "390         1975    101  LBEEFAKA×××××××××\\rLBEEFAKB×××××××××\\rLBEEFAKC...   \n",
       "391         1975    101  LNBSCCBK×××××××××\\r,LNBSCCBE×××××××××\\r,LBESCC...   \n",
       "392         1975    101  LNBSCCBC×××××××××\\r,LNBSCCBH×××××××××\\r,LBESCC...   \n",
       "\n",
       "    car_factory    3 轴距[mm]       长×宽×高[mm] brand_y style  factory  \n",
       "0    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "1    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "2    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "3    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "4    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "5    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "6    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "7    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "8    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "9    北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "10   北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "11   北京现代汽车有限公司  LBE   2805  4855x1835x1485      现代   索纳塔        4  \n",
       "12   北京现代汽车有限公司  LBE   2650  4510x1765x1470      现代    悦动       10  \n",
       "13   北京现代汽车有限公司  LBE   2650  4510x1765x1470      现代    悦动       10  \n",
       "14   北京现代汽车有限公司  LBE   2650  4510x1765x1470      现代    悦动       10  \n",
       "15   北京现代汽车有限公司  LBE   2650  4510x1765x1470      现代    悦动       10  \n",
       "16   北京现代汽车有限公司  LBE   2650  4510x1765x1470      现代    悦动       10  \n",
       "17   北京现代汽车有限公司  LBE   2650  4510x1765x1470      现代    悦动       10  \n",
       "18   北京现代汽车有限公司  LBE   2650  4510x1765x1470      现代    悦动       10  \n",
       "19   北京现代汽车有限公司  LBE   2650  4510x1765x1470      现代    悦动       10  \n",
       "20   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "21   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "22   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "23   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "24   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "25   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "26   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "27   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "28   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "29   北京现代汽车有限公司  LBE   2770  4710x1820x1470      现代    名图       17  \n",
       "..          ...  ...    ...             ...     ...   ...      ...  \n",
       "363  北京现代汽车有限公司  LBE   2650  4542x1775x1490      现代    悦动       20  \n",
       "364  北京现代汽车有限公司  LBE   2650  4542x1775x1490      现代    悦动       20  \n",
       "365  北京现代汽车有限公司  LBE   2650  4542x1775x1490      现代    悦动       20  \n",
       "366  北京现代汽车有限公司  LBE   2650  4542x1775x1490      现代    悦动       20  \n",
       "367  北京现代汽车有限公司  LBE   2650  4542x1775x1490      现代    悦动       20  \n",
       "368  北京现代汽车有限公司  LBE   2650  4542x1775x1490      现代    悦动       20  \n",
       "369  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "370  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "371  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "372  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "373  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "374  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "375  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "376  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "377  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "378  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "379  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "380  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "381  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "382  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "383  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "384  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "385  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "386  北京现代汽车有限公司  LBE   2730  4800x1832x1475      现代    御翔        6  \n",
       "387  北京现代汽车有限公司  LBE   2700  4747x1820x1420      现代   索纳塔       29  \n",
       "388  北京现代汽车有限公司  LBE   2700  4747x1820x1420      现代   索纳塔       29  \n",
       "389  北京现代汽车有限公司  LBE   2700  4747x1820x1420      现代   索纳塔       29  \n",
       "390  北京现代汽车有限公司  LBE   2700  4747x1820x1420      现代   索纳塔       29  \n",
       "391  北京现代汽车有限公司  LNB   2700  4747x1820x1440      现代   索纳塔        1  \n",
       "392  北京现代汽车有限公司  LNB   2700  4747x1820x1440      现代   索纳塔        1  \n",
       "\n",
       "[393 rows x 17 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('现代.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
